create or replace procedure getlengthandnum(p_ONLINE_PLAN in VARCHAR2,p_Number out Number,p_length out Integer) is
    l_PRN_PLAN_ASSDICNO PRN_PLAN.PRN_PLAN_ASSDICNO%TYPE; 
begin
    select PRN_PLAN_ASSDICNO 
    into l_PRN_PLAN_ASSDICNO 
    from PRN_PLAN 
    where p_ONLINE_PLAN = PRN_PLAN_NUM;
    
    select MUL_NUMBER,SB_LEN into p_Number,p_length
    from LASBILLETP                         
    where l_PRN_PLAN_ASSDICNO = TSCD_ID;
  
end getlengthandnum;
/
